|
![](/i/fill.gif) |
SharkD wrote:
> It's also the choice of words that are used for some of the commands
> that irks me. Instead of SELECT I would have used GET. Instead of
> TRIGGER I would have used EVENT.
That's because you're thinking procedurally instead of declaritively.
You're thinking "The server gets a bunch of rows", instead of "the result is
the selection of the rows that meet this criteria." You're thinking "The
server runs this code when it gets an insertion event", rather than "this is
the code that's triggered by an insertion."
> Instead of JOIN I would have used INTERSECT.
Join is closer to a union than an intersection. It's actually a cartesian
product. If you join a 3-row table to a 5-row table, you get a 15-row table.
That said, SQL is indeed one of those languages for which I regularly have
to look up the syntax even for simple stuff. :-)
--
Darren New, San Diego CA, USA (PST)
I ordered stamps from Zazzle that read "Place Stamp Here".
Post a reply to this message
|
![](/i/fill.gif) |